Creating 3nd and 4th Line and Clustered Column Chart visuals 16

Visual 3: Line and Clustered column Chart- Shark Attacks Per Yr & %DOD by Type. 

Step 1:  

a. Create line and clustered column chart for Shark Attacks Per Yr & %DOD by Type and Fatal-
    NonFatal column.
b. This is illustrated by using a GIF, follow along to create this line and clustered column chart.
c. You will copy and paste the previous line and clustered column chart. Ctrl C to copy and
    Ctrl V to paste.
d. In shared axis, delete Decade, Year and Month then drag and drop Fatal-Nonfatal, and Type      columns in the fields.


Step 2: In format go to title and change the title to Shark Attacks Per Yr %DOD by Type




Visual 4 : Line and Clustered column Chart- Shark Attacks Per Yr & %DOD by Species,

               Season & TimeOfDay 

Step 1:

a. Create Shark Attacks Per Yr & %DOD by Species, Seasons &TimeOfDay columns chart.

b. This is illustrated by using a GIF, follow along to create this line and clustered column chart.

c. You will copy and paste the previous line and clustered column chart. Ctrl C to copy

    and Ctrl V to paste.

d. In shared axis, delete Fatal-NonFatal column and Type columns then drag and drop Shark

      Group, SpeciesAll, Season, and Time columns in the shared axis.


Step 2: In format go to title and change the title to Shark Attacks Per Yr %DOD by Species, Season & TimeOfDay.

Add Season and Time columns in the tooltip.



Create a combo chart with two axes:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-combo-chart
Creating 3nd and 4th Line and Clustered Column Chart visuals 16

Visual 3: Line and Clustered column Chart- Shark Attacks Per Yr & %DOD by Type. 

Step 1:  

a. Create line and clustered column chart for Shark Attacks Per Yr & %DOD by Type and Fatal-
    NonFatal column.
b. This is illustrated by using a GIF, follow along to create this line and clustered column chart.
c. You will copy and paste the previous line and clustered column chart. Ctrl C to copy and
    Ctrl V to paste.
d. In shared axis, delete Decade, Year and Month then drag and drop Fatal-Nonfatal, and Type      columns in the fields.


Step 2: In format go to title and change the title to Shark Attacks Per Yr %DOD by Type




Visual 4 : Line and Clustered column Chart- Shark Attacks Per Yr & %DOD by Species,

               Season & TimeOfDay 

Step 1:

a. Create Shark Attacks Per Yr & %DOD by Species, Seasons &TimeOfDay columns chart.

b. This is illustrated by using a GIF, follow along to create this line and clustered column chart.

c. You will copy and paste the previous line and clustered column chart. Ctrl C to copy

    and Ctrl V to paste.

d. In shared axis, delete Fatal-NonFatal column and Type columns then drag and drop Shark

      Group, SpeciesAll, Season, and Time columns in the shared axis.


Step 2: In format go to title and change the title to Shark Attacks Per Yr %DOD by Species, Season & TimeOfDay.

Add Season and Time columns in the tooltip.



Create a combo chart with two axes:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-combo-chart